{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## History data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 197,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "from pandas.plotting import scatter_matrix\n",
    "\n",
    "import seaborn as sns\n",
    "sns.set_style(\"white\")\n",
    "fig_w = 2530\n",
    "fig_h = 1900\n",
    "my_dpi=200\n",
    "\n",
    "import dateutil"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Config plot styles"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 198,
   "metadata": {},
   "outputs": [],
   "source": [
    "plt.style.use('ggplot')\n",
    "\n",
    "from matplotlib import rcParams\n",
    "# plt.rcParams['font.sans-serif'] = ['SimHei']  # 用来正常显示中文标签\n",
    "plt.rcParams['axes.unicode_minus'] = False  # 用来正常显示负号\n",
    "\n",
    "plt.rc('font', family='BabelStone Han', size=13) # 选择你自己电脑上的字体"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Load data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 199,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 如果还没有数据，来群里索要数据文件就行\n",
    "\n",
    "df = pd.read_csv('data/full-data.csv') "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Validate all the possible columns of data frame"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 200,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Unnamed: 0',\n",
       " 'aid',\n",
       " 'uid',\n",
       " 'time',\n",
       " 'duration',\n",
       " 'state',\n",
       " 'view',\n",
       " 'danmaku',\n",
       " 'coin',\n",
       " 'favorite',\n",
       " 'share',\n",
       " 'reply',\n",
       " 'like',\n",
       " 'sectid',\n",
       " 'sectname']"
      ]
     },
     "execution_count": 200,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(df.columns.values)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 201,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['time'] = pd.to_datetime(df['time'],unit='s')#.dt.date"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 195,
   "metadata": {},
   "outputs": [],
   "source": [
    "# df;"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Group by sects"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Get all the sects by sectname"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 202,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'连载剧集'"
      ]
     },
     "execution_count": 202,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sects = df.sectname.unique()\n",
    "sects[0]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Create a dataframe to store the average data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 213,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dealing with: 连载剧集\n",
      "Start date:2017-08-30 13:14:52\n",
      "End date:2017-10-24 09:16:47\n",
      "连载剧集 has 5rows\n",
      "Data saved\n",
      "Dealing with: flash游戏\n",
      "Start date:2010-10-04 23:00:49\n",
      "End date:2012-03-30 07:24:04\n",
      "flash游戏 has 54rows\n",
      "Data saved\n",
      "Dealing with: 单机联机\n",
      "Start date:2009-07-03 11:10:16\n",
      "End date:2018-02-28 07:36:52\n",
      "单机联机 has 316rows\n",
      "Data saved\n",
      "Dealing with: Mugen\n",
      "Start date:2009-07-14 14:59:24\n",
      "End date:2018-02-28 07:10:03\n",
      "Mugen has 315rows\n",
      "Data saved\n",
      "Dealing with: 宅舞\n",
      "Start date:2009-07-15 12:34:50\n",
      "End date:2018-02-28 07:39:39\n",
      "宅舞 has 314rows\n",
      "Data saved\n",
      "Dealing with: 日常\n",
      "Start date:2009-06-26 07:15:45\n",
      "End date:2018-02-28 08:06:32\n",
      "日常 has 316rows\n",
      "Data saved\n",
      "Dealing with: 鬼畜调教\n",
      "Start date:2009-07-14 01:23:55\n",
      "End date:2018-02-28 07:09:05\n",
      "鬼畜调教 has 315rows\n",
      "Data saved\n",
      "Dealing with: MAD-AMV\n",
      "Start date:2009-07-15 07:12:48\n",
      "End date:2018-02-28 08:16:54\n",
      "MAD-AMV has 315rows\n",
      "Data saved\n",
      "Dealing with: MMD-3D\n",
      "Start date:2009-09-16 05:11:11\n",
      "End date:2018-02-28 08:24:46\n",
      "MMD-3D has 308rows\n",
      "Data saved\n",
      "Dealing with: 音MAD\n",
      "Start date:2009-07-09 07:55:49\n",
      "End date:2018-02-28 08:01:25\n",
      "音MAD has 315rows\n",
      "Data saved\n",
      "Dealing with: 综合\n",
      "Start date:2009-07-13 11:36:05\n",
      "End date:2018-02-28 08:37:09\n",
      "综合 has 315rows\n",
      "Data saved\n",
      "Dealing with: 原创音乐\n",
      "Start date:2010-03-18 16:03:38\n",
      "End date:2018-02-28 08:01:19\n",
      "原创音乐 has 290rows\n",
      "Data saved\n",
      "Dealing with: 三次元音乐\n",
      "Start date:2009-07-14 10:46:02\n",
      "End date:2018-02-28 08:49:01\n",
      "三次元音乐 has 315rows\n",
      "Data saved\n",
      "Dealing with: VOCALOID-UTAU\n",
      "Start date:2009-07-12 15:15:53\n",
      "End date:2018-02-28 08:20:34\n",
      "VOCALOID-UTAU has 315rows\n",
      "Data saved\n",
      "Dealing with: 翻唱\n",
      "Start date:2009-07-13 13:17:13\n",
      "End date:2018-02-28 09:01:31\n",
      "翻唱 has 315rows\n",
      "Data saved\n",
      "Dealing with: 完结动画\n",
      "Start date:2009-08-26 06:57:38\n",
      "End date:2018-02-28 03:25:16\n",
      "完结动画 has 310rows\n",
      "Data saved\n",
      "Dealing with: 连载动画\n",
      "Start date:2009-10-06 03:29:23\n",
      "End date:2018-02-28 02:12:46\n",
      "连载动画 has 306rows\n",
      "Data saved\n",
      "Dealing with: 人文历史\n",
      "Start date:2010-10-11 05:21:01\n",
      "End date:2018-02-28 07:18:50\n",
      "人文历史 has 269rows\n",
      "Data saved\n",
      "Dealing with: 演讲-公开课\n",
      "Start date:2010-06-17 00:21:36\n",
      "End date:2018-02-28 09:16:24\n",
      "演讲-公开课 has 281rows\n",
      "Data saved\n",
      "Dealing with: 未知\n",
      "Start date:2015-05-11 08:43:27\n",
      "End date:2015-05-11 08:43:27\n",
      "未知 has 0rows\n",
      "Dealing with: MMD.3D\n",
      "Start date:2011-09-01 02:19:42\n",
      "End date:2014-05-09 03:06:24\n",
      "MMD.3D has 98rows\n",
      "Data saved\n",
      "Dealing with: 短片-手书-配音\n",
      "Start date:2009-07-14 01:34:49\n",
      "End date:2018-02-28 09:21:30\n",
      "短片-手书-配音 has 315rows\n",
      "Data saved\n",
      "Dealing with: 资讯\n",
      "Start date:2010-08-30 13:33:38\n",
      "End date:2018-02-28 13:18:07\n",
      "资讯 has 273rows\n",
      "Data saved\n",
      "Dealing with: OP-ED-OST\n",
      "Start date:2009-09-20 09:22:24\n",
      "End date:2018-02-28 09:09:17\n",
      "OP-ED-OST has 308rows\n",
      "Data saved\n",
      "Dealing with: 演奏\n",
      "Start date:2009-07-21 03:20:03\n",
      "End date:2018-02-28 09:28:44\n",
      "演奏 has 314rows\n",
      "Data saved\n",
      "Dealing with: 网络游戏\n",
      "Start date:2010-04-28 12:27:00\n",
      "End date:2018-02-28 10:18:47\n",
      "网络游戏 has 286rows\n",
      "Data saved\n",
      "Dealing with: 单机游戏\n",
      "Start date:2012-06-25 14:18:48\n",
      "End date:2014-08-14 04:34:01\n",
      "单机游戏 has 77rows\n",
      "Data saved\n",
      "Dealing with: 综艺\n",
      "Start date:2010-10-01 05:01:59\n",
      "End date:2018-02-28 10:33:32\n",
      "综艺 has 270rows\n",
      "Data saved\n",
      "Dealing with: 动物圈\n",
      "Start date:2010-02-23 06:23:13\n",
      "End date:2018-02-28 10:44:47\n",
      "动物圈 has 292rows\n",
      "Data saved\n",
      "Dealing with: 美食圈\n",
      "Start date:2010-03-25 04:19:33\n",
      "End date:2018-02-28 10:55:24\n",
      "美食圈 has 289rows\n",
      "Data saved\n",
      "Dealing with: 喵星人\n",
      "Start date:2014-04-22 11:31:46\n",
      "End date:2014-04-22 11:31:46\n",
      "喵星人 has 0rows\n",
      "Dealing with: 美食视频\n",
      "Start date:2014-04-18 14:33:01\n",
      "End date:2014-08-21 05:14:23\n",
      "美食视频 has 12rows\n",
      "Data saved\n",
      "Dealing with: 电影相关\n",
      "Start date:2013-02-07 02:20:21\n",
      "End date:2017-10-31 15:01:36\n",
      "电影相关 has 172rows\n",
      "Data saved\n",
      "Dealing with: 其他国家\n",
      "Start date:2016-02-22 12:41:35\n",
      "End date:2017-12-20 10:59:06\n",
      "其他国家 has 66rows\n",
      "Data saved\n",
      "Dealing with: 短片\n",
      "Start date:2010-03-24 18:05:57\n",
      "End date:2018-02-28 11:01:11\n",
      "短片 has 289rows\n",
      "Data saved\n",
      "Dealing with: 特摄\n",
      "Start date:2010-06-21 20:00:07\n",
      "End date:2018-02-28 10:43:29\n",
      "特摄 has 280rows\n",
      "Data saved\n",
      "Dealing with: 剧场版\n",
      "Start date:2014-08-01 11:16:26\n",
      "End date:2015-03-17 14:01:30\n",
      "剧场版 has 22rows\n",
      "Data saved\n",
      "Dealing with: 数码\n",
      "Start date:2010-07-22 15:58:01\n",
      "End date:2018-02-28 11:16:49\n",
      "数码 has 277rows\n",
      "Data saved\n",
      "Dealing with: 星海\n",
      "Start date:2011-03-22 17:55:22\n",
      "End date:2018-02-28 11:21:27\n",
      "星海 has 253rows\n",
      "Data saved\n",
      "Dealing with: 机械\n",
      "Start date:2010-02-14 19:57:33\n",
      "End date:2018-02-28 11:25:32\n",
      "机械 has 293rows\n",
      "Data saved\n",
      "Dealing with: GMV\n",
      "Start date:2010-07-26 14:57:28\n",
      "End date:2018-02-28 11:26:16\n",
      "GMV has 277rows\n",
      "Data saved\n",
      "Dealing with: 野生技术协会\n",
      "Start date:2009-09-09 01:09:09\n",
      "End date:2018-02-28 11:38:47\n",
      "野生技术协会 has 309rows\n",
      "Data saved\n",
      "Dealing with: 趣味科普人文\n",
      "Start date:2009-10-14 04:38:56\n",
      "End date:2018-02-28 11:49:46\n",
      "趣味科普人文 has 305rows\n",
      "Data saved\n",
      "Dealing with: 其他\n",
      "Start date:2009-09-13 07:01:43\n",
      "End date:2018-02-28 14:17:25\n",
      "其他 has 309rows\n",
      "Data saved\n",
      "Dealing with: 人力VOCALOID\n",
      "Start date:2009-11-20 03:59:58\n",
      "End date:2018-02-28 11:53:18\n",
      "人力VOCALOID has 302rows\n",
      "Data saved\n",
      "Dealing with: 教程演示\n",
      "Start date:2010-03-02 03:33:45\n",
      "End date:2018-02-27 15:43:02\n",
      "教程演示 has 291rows\n",
      "Data saved\n",
      "Dealing with: 电视剧相关\n",
      "Start date:2012-10-14 10:14:57\n",
      "End date:2017-10-31 22:39:57\n",
      "电视剧相关 has 184rows\n",
      "Data saved\n",
      "Dealing with: 音乐选集\n",
      "Start date:2009-07-09 06:07:51\n",
      "End date:2018-02-28 12:15:05\n",
      "音乐选集 has 315rows\n",
      "Data saved\n",
      "Dealing with: Korea相关\n",
      "Start date:2011-08-11 04:16:29\n",
      "End date:2018-02-28 12:28:16\n",
      "Korea相关 has 239rows\n",
      "Data saved\n",
      "Dealing with: 音游\n",
      "Start date:2009-07-21 14:14:31\n",
      "End date:2018-02-28 12:21:43\n",
      "音游 has 314rows\n",
      "Data saved\n",
      "Dealing with: 明星\n",
      "Start date:2012-06-10 10:56:41\n",
      "End date:2018-02-28 12:45:54\n",
      "明星 has 208rows\n",
      "Data saved\n",
      "Dealing with: 搞笑\n",
      "Start date:2010-02-09 09:37:26\n",
      "End date:2018-02-28 12:50:05\n",
      "搞笑 has 294rows\n",
      "Data saved\n",
      "Dealing with: 实况解说\n",
      "Start date:2015-04-08 17:53:37\n",
      "End date:2015-04-09 01:19:13\n",
      "实况解说 has 0rows\n",
      "Dealing with: 游戏集锦\n",
      "Start date:2015-04-08 23:17:14\n",
      "End date:2015-04-08 23:42:10\n",
      "游戏集锦 has 0rows\n",
      "Dealing with: 欧美电影\n",
      "Start date:2016-02-22 11:45:41\n",
      "End date:2018-02-12 15:55:51\n",
      "欧美电影 has 72rows\n",
      "Data saved\n",
      "Dealing with: 日本电影\n",
      "Start date:2016-05-11 06:11:29\n",
      "End date:2018-01-26 08:49:37\n",
      "日本电影 has 62rows\n",
      "Data saved\n",
      "Dealing with: 国产电影\n",
      "Start date:2012-01-03 08:49:05\n",
      "End date:2018-02-28 02:34:13\n",
      "国产电影 has 224rows\n",
      "Data saved\n",
      "Dealing with: 官方延伸\n",
      "Start date:2010-01-07 03:46:26\n",
      "End date:2018-02-28 11:37:35\n",
      "官方延伸 has 297rows\n",
      "Data saved\n",
      "Dealing with: 国产动画\n",
      "Start date:2010-01-23 22:47:56\n",
      "End date:2018-02-28 03:30:00\n",
      "国产动画 has 295rows\n",
      "Data saved\n",
      "Dealing with: 三次元舞蹈\n",
      "Start date:2010-09-08 21:56:54\n",
      "End date:2018-02-28 12:40:54\n",
      "三次元舞蹈 has 272rows\n",
      "Data saved\n",
      "Dealing with: 舞蹈教程\n",
      "Start date:2011-04-02 11:17:02\n",
      "End date:2018-02-28 04:07:41\n",
      "舞蹈教程 has 252rows\n",
      "Data saved\n",
      "Dealing with: 美妆\n",
      "Start date:2014-04-21 18:15:57\n",
      "End date:2018-02-28 13:06:05\n",
      "美妆 has 140rows\n",
      "Data saved\n",
      "Dealing with: 服饰\n",
      "Start date:2013-11-24 12:11:47\n",
      "End date:2018-02-28 13:00:58\n",
      "服饰 has 155rows\n",
      "Data saved\n",
      "Dealing with: 手工\n",
      "Start date:2010-09-29 17:44:14\n",
      "End date:2018-02-28 13:11:51\n",
      "手工 has 270rows\n",
      "Data saved\n",
      "Dealing with: 绘画\n",
      "Start date:2010-03-17 00:33:51\n",
      "End date:2018-02-28 12:54:55\n",
      "绘画 has 290rows\n",
      "Data saved\n",
      "Dealing with: 运动\n",
      "Start date:2010-07-24 08:31:15\n",
      "End date:2018-02-28 13:19:40\n",
      "运动 has 277rows\n",
      "Data saved\n",
      "Dealing with: 健身\n",
      "Start date:2014-07-28 13:04:28\n",
      "End date:2018-02-28 13:00:58\n",
      "健身 has 131rows\n",
      "Data saved\n",
      "Dealing with: 广告\n",
      "Start date:2009-07-13 18:34:45\n",
      "End date:2018-02-28 13:20:06\n",
      "广告 has 315rows\n",
      "Data saved\n",
      "Dealing with: 国产原创相关\n",
      "Start date:2009-09-30 12:42:21\n",
      "End date:2018-02-28 13:19:43\n",
      "国产原创相关 has 307rows\n",
      "Data saved\n",
      "Dealing with: 布袋戏\n",
      "Start date:2010-02-14 11:05:42\n",
      "End date:2018-02-28 09:27:27\n",
      "布袋戏 has 293rows\n",
      "Data saved\n",
      "Dealing with: 电子竞技\n",
      "Start date:2009-07-09 19:15:16\n",
      "End date:2018-02-28 13:49:44\n",
      "电子竞技 has 315rows\n",
      "Data saved\n",
      "Dealing with: 手机游戏\n",
      "Start date:2010-02-06 19:12:21\n",
      "End date:2018-02-28 14:08:13\n",
      "手机游戏 has 294rows\n",
      "Data saved\n",
      "Dealing with: 桌游棋牌\n",
      "Start date:2010-03-27 14:17:19\n",
      "End date:2018-02-28 14:07:32\n",
      "桌游棋牌 has 289rows\n",
      "Data saved\n",
      "Dealing with: ASMR\n",
      "Start date:2010-05-29 03:11:51\n",
      "End date:2018-02-28 14:22:05\n",
      "ASMR has 283rows\n",
      "Data saved\n",
      "Dealing with: 汽车\n",
      "Start date:2011-01-12 13:41:51\n",
      "End date:2018-02-28 14:19:35\n",
      "汽车 has 260rows\n",
      "Data saved\n",
      "Dealing with: 科学探索\n",
      "Start date:2010-06-03 09:55:15\n",
      "End date:2018-02-28 10:01:16\n",
      "科学探索 has 282rows\n",
      "Data saved\n",
      "Dealing with: 热血军事\n",
      "Start date:2010-12-23 06:50:28\n",
      "End date:2018-02-28 06:08:24\n",
      "热血军事 has 262rows\n",
      "Data saved\n",
      "Dealing with: 舌尖上的旅行\n",
      "Start date:2011-06-08 23:18:17\n",
      "End date:2018-02-28 10:58:27\n",
      "舌尖上的旅行 has 245rows\n",
      "Data saved\n",
      "Dealing with: 影视杂谈\n",
      "Start date:2011-07-08 04:36:59\n",
      "End date:2018-02-28 14:28:54\n",
      "影视杂谈 has 242rows\n",
      "Data saved\n",
      "Dealing with: 影视剪辑\n",
      "Start date:2010-02-03 14:12:18\n",
      "End date:2018-02-28 15:00:27\n",
      "影视剪辑 has 294rows\n",
      "Data saved\n",
      "Dealing with: 预告 资讯\n",
      "Start date:2009-06-26 07:11:36\n",
      "End date:2018-02-28 14:45:07\n",
      "预告 资讯 has 316rows\n",
      "Data saved\n",
      "Dealing with: 国产剧\n",
      "Start date:2011-02-04 11:04:49\n",
      "End date:2018-02-28 08:04:43\n",
      "国产剧 has 258rows\n",
      "Data saved\n",
      "Dealing with: 海外剧\n",
      "Start date:2014-08-09 05:55:52\n",
      "End date:2018-02-25 02:00:00\n",
      "海外剧 has 129rows\n",
      "Data saved\n"
     ]
    }
   ],
   "source": [
    "index_store = ['date','tduration', 'tview', 'tcoin', 'tfavorite', 'tlike','totalv','mostaid']\n",
    "\n",
    "# idx = 3\n",
    "for idx in np.arange(len(sects) ):\n",
    "    df_sect = df[df['sectname']==sects[idx]] \n",
    "\n",
    "    max_date = df_sect.time.max()\n",
    "    min_date = df_sect.time.min()\n",
    "    sect_id_str = str(df_sect.sectid.unique()[0])\n",
    "    sect_name_str = str(sects[idx])\n",
    "    print('Dealing with: '+sect_name_str)\n",
    "    print('Start date:' + str(min_date))\n",
    "    print('End date:' + str(max_date))\n",
    "\n",
    "    dateseries = pd.date_range(start=min_date, end=max_date, freq='10D')\n",
    "\n",
    "\n",
    "    df_store = pd.DataFrame(columns=index_store)\n",
    "\n",
    "\n",
    "    ########\n",
    "    # Loop Through Dates\n",
    "    ########\n",
    "\n",
    "    # d_idx = 0\n",
    "\n",
    "    for d_idx in np.arange(len(dateseries) -1 ):\n",
    "        df_sect_temp = df_sect[df_sect['time'].between(dateseries[d_idx],dateseries[d_idx+1])]\n",
    "\n",
    "        if  not df_sect_temp.empty:\n",
    "            mostviewed_temp = df_sect_temp.loc[df_sect_temp['view'].idxmax()].aid\n",
    "            totalrows_temp = len(df_sect_temp.index)\n",
    "            sumviews_temp = np.sum(df_sect_temp['view'].values)\n",
    "            sumduration_temp = np.sum(df_sect_temp['duration'].values)\n",
    "            sumcoin_temp = np.sum(df_sect_temp['coin'].values)\n",
    "            sumfav_temp = np.sum(df_sect_temp['favorite'].values)\n",
    "            sumlike_temp = np.sum(df_sect_temp['like'].values)\n",
    "\n",
    "            df_sect_temp2 = df_sect_temp.mean().round(2)\n",
    "\n",
    "            values_temp = [dateseries[d_idx] , sumduration_temp, sumviews_temp, sumcoin_temp, sumfav_temp, sumlike_temp, totalrows_temp ,mostviewed_temp]\n",
    "\n",
    "            df_store_temp = pd.DataFrame([values_temp],columns=['date','tduration', 'tview', 'tcoin', 'tfavorite', 'tlike','totalv','mostaid'])\n",
    "\n",
    "\n",
    "            df_store = (pd.concat([df_store, df_store_temp]) ).reset_index(drop=True)\n",
    "        else:\n",
    "            values_temp = [dateseries[d_idx] , 0, 0, 0, 0, 0, 0 ,0]\n",
    "\n",
    "            df_store_temp = pd.DataFrame([values_temp],columns=['date','tduration', 'tview', 'tcoin', 'tfavorite', 'tlike','totalv','mostaid'])\n",
    "\n",
    "            df_store = (pd.concat([df_store, df_store_temp]) ).reset_index(drop=True)\n",
    "\n",
    "            \n",
    "    print(sect_name_str + ' has ' + str( len(df_store.index) ) + 'rows' )\n",
    "    \n",
    "    if  not df_store.empty:\n",
    "        df_store['date'] = df_store['date'].dt.date\n",
    "\n",
    "        df_store.to_csv('export/batch/'+sect_id_str+'-'+sect_name_str+'.csv', sep=',', encoding='utf-8')\n",
    "\n",
    "        print('Data saved')        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
